{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Bottling Spec","Winery Spec","Labelling Spec","Sticker Placement","Tankers Reference","Dry Goods Availability","Glass Codes"],"not_rendered":{"charts":0,"images":7,"macros":0,"external_links":0,"defined_names":3,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Bottling Spec","index":0,"n_rows":50,"n_cols":10,"rows_kept":50,"cut":false,"hidden":false,"merged":[[6,1,6,10],[7,3,7,4],[30,1,30,2],[31,1,31,2],[32,1,32,2],[33,1,33,2],[28,1,28,2],[20,3,20,4],[21,3,21,4],[22,3,22,4],[23,3,23,4],[24,3,24,4],[25,3,25,4],[26,3,26,4],[27,3,27,4],[28,3,28,4],[23,1,23,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[17,3,17,4],[18,3,18,4],[20,1,20,2],[21,1,21,2],[22,1,22,2],[19,1,19,10],[17,5,17,6],[18,5,18,6],[20,5,20,6],[21,5,21,6],[22,5,22,6],[23,5,23,6],[21,7,21,8],[18,9,18,10],[20,9,20,10],[21,9,21,10],[22,9,22,10],[23,9,23,10],[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[16,3,16,4],[16,7,16,8],[17,7,17,8],[18,7,18,8],[20,7,20,8],[10,1,10,2],[11,1,11,2],[7,1,7,2],[12,1,12,2],[13,1,13,2],[8,1,8,2],[9,1,9,2],[14,1,14,2],[8,3,8,4],[9,3,9,4],[10,3,10,4],[11,3,11,4],[12,3,12,4],[13,3,13,4],[14,3,14,4],[5,5,5,6],[1,9,1,10],[5,2,5,3],[5,8,5,9],[0,0,0,10],[3,5,3,6],[3,1,3,3],[3,8,3,10],[2,4,2,5],[1,1,1,3],[2,1,2,3],[49,0,53,0],[42,1,42,10],[29,1,29,10],[34,1,34,2],[35,1,35,2],[36,1,36,2],[37,1,37,2],[38,1,38,2],[39,1,39,2],[40,1,40,2],[41,1,41,2],[30,3,30,4],[30,5,30,6],[31,3,31,4],[34,3,34,4],[34,5,34,6],[35,3,35,4],[35,5,35,6],[36,3,36,4],[36,5,36,6],[31,5,31,6],[32,3,32,4],[33,3,33,4],[33,5,33,6],[43,1,43,2],[43,3,43,4],[43,5,43,6],[37,3,37,4],[37,5,37,6],[38,3,38,4],[38,5,38,6],[39,3,39,4],[39,5,39,6],[44,1,44,2],[46,1,46,2],[45,1,45,2],[47,1,47,2],[48,1,48,2],[46,5,46,6],[45,5,45,6],[47,5,47,6],[44,5,44,6],[27,5,27,6],[28,5,28,6],[12,5,12,6],[13,5,13,6],[14,5,14,6],[15,5,15,6],[16,5,16,6],[48,5,48,6],[44,3,44,4],[46,3,46,4],[45,3,45,4],[47,3,47,4],[48,3,48,4],[40,3,40,4],[40,5,40,6],[41,3,41,4],[41,5,41,6],[15,3,15,4],[32,5,32,6],[15,9,15,10],[16,9,16,10],[17,9,17,10],[7,5,7,6],[7,7,7,8],[8,7,8,8],[9,7,9,8],[8,5,8,6],[9,5,9,6],[10,5,10,6],[11,5,11,6],[32,7,32,8],[7,9,7,10],[8,9,8,10],[9,9,9,10],[10,9,10,10],[11,9,11,10],[12,9,12,10],[13,9,13,10],[14,9,14,10],[24,5,24,6],[25,5,25,6],[26,5,26,6],[33,7,33,8],[22,7,22,8],[23,7,23,8],[24,7,24,8],[25,7,25,8],[26,7,26,8],[10,7,10,8],[11,7,11,8],[12,7,12,8],[13,7,13,8],[15,7,15,8],[14,7,14,8],[27,12,27,13],[46,7,46,8],[45,7,45,8],[47,7,47,8],[48,7,48,8],[30,9,30,10],[31,9,31,10],[32,9,32,10],[33,9,33,10],[34,9,34,10],[39,7,39,8],[40,7,40,8],[41,7,41,8],[43,7,43,8],[44,7,44,8],[34,7,34,8],[35,7,35,8],[36,7,36,8],[37,7,37,8],[38,7,38,8],[27,7,27,8],[28,7,28,8],[30,7,30,8],[31,7,31,8],[49,1,49,10],[50,1,50,10],[51,1,51,10],[52,1,52,10],[53,1,53,10],[35,12,35,13],[24,9,24,10],[25,9,25,10],[26,9,26,10],[27,9,27,10],[28,9,28,10],[45,9,45,10],[47,9,47,10],[48,9,48,10],[40,9,40,10],[41,9,41,10],[43,9,43,10],[44,9,44,10],[46,9,46,10],[35,9,35,10],[36,9,36,10],[37,9,37,10],[38,9,38,10],[39,9,39,10]]}
["VinPro Bottling and Labelling Specification Sheet"]
["Customer: ",null,null,null,null,null,null,null,"Vinpro WSMP number","VINPRO102"]
["Client Name:",null,null,null,"Client Required at Startup: ",null,null,null,"Client WSMP Number"]
["Contact Name: ",null,null,null,"Phone: ",null,null,"Email: "]
["Product and Vintage  to Bottle: ",null,null,null,"Region of Wine",null,null,"Organic:",null,"Biogro #: "]
["Litres Booked: ",null,"Bottling Date: (Office use only)",null,null,"Date Received: (Office use only)  ",null,null,"Job Number: (Office use only)"]
[]
["BOTTLE & CLOSURE",1,null,2]
["Bottle Supplier:",null,null,{"$f":"IF(OR(B9=\"\",D$8=\"\"),\"\",B9)","v":""},null,{"$f":"IF(OR(D9=\"\",F$8=\"\"),\"\",D9)","v":""},null,{"$f":"IF(OR(F9=\"\",H$8=\"\"),\"\",F9)","v":""},null,{"$f":"IF(OR(H9=\"\",J$8=\"\"),\"\",H9)","v":""}]
["Bottle Type:",null,null,null,null,null,null,"",null,{"$f":"IF(OR(H10=\"\",J$8=\"\"),\"\",H10)","v":""}]
["Closure Type:",null,null,{"$f":"IF(OR(B11=\"\",D$8=\"\"),\"\",B11)","v":""},null,{"$f":"IF(OR(D11=\"\",F$8=\"\"),\"\",D11)","v":""},null,"",null,{"$f":"IF(OR(H11=\"\",J$8=\"\"),\"\",H11)","v":""}]
["Closure Supplier:",null,null,{"$f":"IF(OR(B12=\"\",D$8=\"\"),\"\",B12)","v":""},null,{"$f":"IF(OR(D12=\"\",F$8=\"\"),\"\",D12)","v":""},null,"",null,{"$f":"IF(OR(H12=\"\",J$8=\"\"),\"\",H12)","v":""}]
[{"$f":"IF(IFERROR(FIND(\"BLACK\",UPPER(B13&D13&F13&H13&J13)),0)>0,\"Closure Color: matt or satin?\",\"Closure Color:\")","v":"Closure Color:"},null,null,null,null,null,null,""]
["Closure Description:",null,null,{"$f":"IF(OR(B14=\"\",D$8=\"\"),\"\",B14)","v":""},null,{"$f":"IF(OR(D14=\"\",F$8=\"\"),\"\",D14)","v":""},null,"",null,{"$f":"IF(OR(H14=\"\",J$8=\"\"),\"\",H14)","v":""}]
["Closure Code:",null,null,{"$f":"IF(OR(B15=\"\",D$8=\"\"),\"\",B15)","v":""},null,{"$f":"IF(OR(D15=\"\",F$8=\"\"),\"\",D15)","v":""},null,"",null,{"$f":"IF(OR(H15=\"\",J$8=\"\"),\"\",H15)","v":""}]
["Capsule Type:",{"$f":"IF(OR(B$11=\"Screwcap (knurl)\",B$11=\"Screwcap (no knurl)\",B$11=\"Lux (savin)\",B$11=\"Lux (stelvin)\"),\"N/A\",\"\")","v":""},null,{"$f":"IF(OR(D$11=\"Screwcap (knurl)\",D$11=\"Screwcap (no knurl)\",D$11=\"Lux (savin)\",D$11=\"Lux (stelvin)\"),\"N/A\",\"\")","v":""},null,{"$f":"IF(OR(F$11=\"Screwcap (knurl)\",F$11=\"Screwcap (no knurl)\",F$11=\"Lux (savin)\",F$11=\"Lux (stelvin)\"),\"N/A\",\"\")","v":""},null,{"$f":"IF(OR(H$11=\"Screwcap (knurl)\",H$11=\"Screwcap (no knurl)\",H$11=\"Lux (savin)\",H$11=\"Lux (stelvin)\"),\"N/A\",\"\")","v":""},null,{"$f":"IF(OR(J$11=\"Screwcap (knurl)\",J$11=\"Screwcap (no knurl)\",J$11=\"Lux (savin)\",J$11=\"Lux (stelvin)\"),\"N/A\",\"\")","v":""}]
["Capsule Supplier:",{"$f":"IF(OR(B$11=\"Screwcap (knurl)\",B$11=\"Screwcap (no knurl)\",B$11=\"Lux (savin)\",B$11=\"Lux (stelvin)\"),\"N/A\",\"\")","v":""},null,{"$f":"IF(OR(D$11=\"Screwcap (knurl)\",D$11=\"Screwcap (no knurl)\",D$11=\"Lux (savin)\",D$11=\"Lux (stelvin)\"),\"N/A\",\"\")","v":""},null,"",null,"",null,""]
["Capsule Colour:","",null,"",null,"",null,"",null,""]
["Bottle Laser Code:",null,null,{"$f":"IF(OR(B19=\"\",D$8=\"\"),\"\",B19)","v":""},null,{"$f":"IF(OR(D19=\"\",F$8=\"\"),\"\",D19)","v":""},null,{"$f":"IF(OR(F19=\"\",H$8=\"\"),\"\",F19)","v":""},null,{"$f":"IF(OR(H19=\"\",J$8=\"\"),\"\",H19)","v":""}]
["ASSEMBLIES & LABELS"]
["Pack Type:",null,null,{"$f":"IF(OR(B21=\"\",D$8=\"\"),\"\",B21)","v":""},null,{"$f":"IF(OR(D21=\"\",F$8=\"\"),\"\",D21)","v":""},null,{"$f":"IF(OR(F21=\"\",H$8=\"\"),\"\",F21)","v":""},null,{"$f":"IF(OR(H21=\"\",J$8=\"\"),\"\",H21)","v":""}]
["Quantity To Produce: ",null,null,{"$f":"IF(OR(B22=\"\",D$8=\"\"),\"\",B22)","v":""},null,{"$f":"IF(OR(D22=\"\",F$8=\"\"),\"\",D22)","v":""},null,{"$f":"IF(OR(F22=\"\",H$8=\"\"),\"\",F22)","v":""},null,{"$f":"IF(OR(H22=\"\",J$8=\"\"),\"\",H22)","v":""}]
["Country on Label/Cleanskin:",null,null,{"$f":"IF(OR(B23=\"\",D$8=\"\"),\"\",B23)","v":""},null,null,null,{"$f":"IF(OR(F23=\"\",H$8=\"\"),\"\",F23)","v":""},null,{"$f":"IF(OR(H23=\"\",J$8=\"\"),\"\",H23)","v":""}]
["Extra Label Information:",null,null,{"$f":"IF(OR(B24=\"\",D$8=\"\"),\"\",B24)","v":""},null,{"$f":"IF(OR(D24=\"\",F$8=\"\"),\"\",D24)","v":""},null,{"$f":"IF(OR(F24=\"\",H$8=\"\"),\"\",F24)","v":""},null,{"$f":"IF(OR(H24=\"\",J$8=\"\"),\"\",H24)","v":""}]
["Runout (indicate with #):"]
["Label Type:",null,null,{"$f":"IF(OR(B26=\"\",D$8=\"\"),\"\",B26)","v":""},null,{"$f":"IF(OR(D26=\"\",F$8=\"\"),\"\",D26)","v":""},null,{"$f":"IF(OR(F26=\"\",H$8=\"\"),\"\",F26)","v":""},null,{"$f":"IF(OR(H26=\"\",J$8=\"\"),\"\",H26)","v":""}]
["Front Label Height (in mm):",null,null,{"$f":"IF(OR(B27=\"\",D$8=\"\"),\"\",B27)","v":""},null,{"$f":"IF(OR(D27=\"\",F$8=\"\"),\"\",D27)","v":""},null,{"$f":"IF(OR(F27=\"\",H$8=\"\"),\"\",F27)","v":""},null,{"$f":"IF(OR(H27=\"\",J$8=\"\"),\"\",H27)","v":""}]
["Back Label Height (in mm):",null,null,{"$f":"IF(OR(B28=\"\",D$8=\"\"),\"\",B28)","v":""},null,{"$f":"IF(OR(D28=\"\",F$8=\"\"),\"\",D28)","v":""},null,{"$f":"IF(OR(F28=\"\",H$8=\"\"),\"\",F28)","v":""},null,{"$f":"IF(OR(H28=\"\",J$8=\"\"),\"\",H28)","v":""}]
["Label Supplier:",null,null,{"$f":"IF(OR(B29=\"\",D$8=\"\"),\"\",B29)","v":""},null,{"$f":"IF(OR(D29=\"\",F$8=\"\"),\"\",D29)","v":""},null,{"$f":"IF(OR(F29=\"\",H$8=\"\"),\"\",F29)","v":""},null,{"$f":"IF(OR(H29=\"\",J$8=\"\"),\"\",H29)","v":""}]
["CARTONS & MARKINGS"]
["Carton Type:",null,null,{"$f":"IF(OR(B31=\"\",D$8=\"\"),\"\",B31)","v":""},null,{"$f":"IF(OR(D31=\"\",F$8=\"\"),\"\",D31)","v":""},null,{"$f":"IF(OR(F31=\"\",H$8=\"\"),\"\",F31)","v":""},null,{"$f":"IF(OR(H31=\"\",J$8=\"\"),\"\",H31)","v":""}]
["Carton Supplier:",null,null,{"$f":"IF(OR(B32=\"\",D$8=\"\"),\"\",B32)","v":""},null,{"$f":"IF(OR(D32=\"\",F$8=\"\"),\"\",D32)","v":""},null,{"$f":"IF(OR(F32=\"\",H$8=\"\"),\"\",F32)","v":""},null,{"$f":"IF(OR(H32=\"\",J$8=\"\"),\"\",H32)","v":""}]
["Carton Supplier Code:",null,null,{"$f":"IF(OR(B33=\"\",D$8=\"\"),\"\",B33)","v":""},null,{"$f":"IF(OR(D33=\"\",F$8=\"\"),\"\",D33)","v":""},null,{"$f":"IF(OR(F33=\"\",H$8=\"\"),\"\",F33)","v":""},null,{"$f":"IF(OR(H33=\"\",J$8=\"\"),\"\",H33)","v":""}]
["Carton Markings :",null,null,{"$f":"IF(OR(B34=\"\",D$8=\"\"),\"\",B34)","v":""},null,{"$f":"IF(OR(D34=\"\",F$8=\"\"),\"\",D34)","v":""},null,{"$f":"IF(OR(F34=\"\",H$8=\"\"),\"\",F34)","v":""},null,{"$f":"IF(OR(H34=\"\",J$8=\"\"),\"\",H34)","v":""}]
["Text on Barcode:",{"$f":"IF(OR(B$34=\"None\",B$34=\"Client Supplied Carton Label\",B$34=\"VinPro Produced Label\"),\"N/A\",\"\")","v":""},null,{"$f":"IF(OR(D$34=\"None\",D$34=\"Client Supplied Carton Label\",D$34=\"VinPro Produced Label\"),\"N/A\",\"\")","v":""},null,{"$f":"IF(OR(F$34=\"None\",F$34=\"Client Supplied Carton Label\",F$34=\"VinPro Produced Label\"),\"N/A\",\"\")","v":""},null,{"$f":"IF(OR(H$34=\"None\",H$34=\"Client Supplied Carton Label\",H$34=\"VinPro Produced Label\"),\"N/A\",\"\")","v":""},null,{"$f":"IF(OR(J$34=\"None\",J$34=\"Client Supplied Carton Label\",J$34=\"VinPro Produced Label\"),\"N/A\",\"\")","v":""}]
["Barcode Number:",{"$f":"IF(OR(B$34=\"None\",B$34=\"Client Supplied Carton Label\",B$34=\"VinPro Produced Label\"),\"N/A\",\"\")","v":""},null,{"$f":"IF(OR(D$34=\"None\",D$34=\"Client Supplied Carton Label\",D$34=\"VinPro Produced Label\"),\"N/A\",\"\")","v":""},null,{"$f":"IF(OR(F$34=\"None\",F$34=\"Client Supplied Carton Label\",F$34=\"VinPro Produced Label\"),\"N/A\",\"\")","v":""},null,{"$f":"IF(OR(H$34=\"None\",H$34=\"Client Supplied Carton Label\",H$34=\"VinPro Produced Label\"),\"N/A\",\"\")","v":""},null,{"$f":"IF(OR(J$34=\"None\",J$34=\"Client Supplied Carton Label\",J$34=\"VinPro Produced Label\"),\"N/A\",\"\")","v":""}]
["Front Bottle Label:",null,null,{"$f":"IF(OR(B37=\"\",D$8=\"\"),\"\",B37)","v":""},null,{"$f":"IF(OR(D37=\"\",F$8=\"\"),\"\",D37)","v":""},null,{"$f":"IF(OR(F37=\"\",H$8=\"\"),\"\",F37)","v":""},null,{"$f":"IF(OR(H37=\"\",J$8=\"\"),\"\",H37)","v":""}]
["Inkjet Code Required:",null,null,"",null,"",null,"",null,""]
["Inkjet Code Text:",null,null,"",null,"",null,"",null,""]
["Pregnancy Warning Required:"]
["Dividers:",null,null,"",null,"",null,"",null,""]
["Dividers Supplier:",null,null,"",null,"",null,"",null,""]
["PALLETS & STORAGE"]
["Pallet Type:"]
["Pallet Wrapping:",null,null,{"$f":"IF(OR(B45=\"\",D$8=\"\"),\"\",B45)","v":""},null,{"$f":"IF(OR(D45=\"\",F$8=\"\"),\"\",D45)","v":""},null,{"$f":"IF(OR(F45=\"\",H$8=\"\"),\"\",F45)","v":""},null,{"$f":"IF(OR(H45=\"\",J$8=\"\"),\"\",H45)","v":""}]
["Finished Wine Storage:",null,null,"",null,"",null,"",null,""]
["Finished Wine Transport: ",null,null,"",null,"",null,"",null,""]
["Dry Goods Storage:",null,null,"",null,"",null,"",null,""]
["Label Storage:",null,null,"",null,"",null,"",null,""]
["COMMENTS:"]

{"sheet":"Winery Spec","index":1,"n_rows":22,"n_cols":10,"rows_kept":22,"cut":false,"hidden":false,"merged":[[14,6,15,12],[16,10,16,12],[15,0,15,1],[20,0,20,4],[14,0,14,2],[15,3,15,4],[3,7,3,9],[9,9,9,12],[7,9,7,12],[8,9,8,12],[10,1,10,2],[4,5,24,5],[11,0,12,4],[10,6,11,12],[17,6,18,12],[8,0,8,4],[9,3,10,4],[6,3,7,4],[4,0,4,4],[4,6,4,12],[6,6,6,12],[23,6,24,12],[5,0,5,1],[5,2,5,3],[12,6,12,8],[12,10,12,12],[5,6,5,10],[9,6,9,8],[13,0,13,2],[0,0,0,12],[1,2,1,6],[1,7,1,8],[1,9,1,12],[2,1,2,2],[2,3,2,6],[2,9,2,12],[2,7,2,8],[3,1,3,4],[3,5,3,6],[13,10,13,12],[8,6,8,8],[7,6,7,8],[9,1,9,2],[3,10,3,12],[22,6,22,12],[24,17,24,18],[22,0,22,4],[16,6,16,8],[21,17,21,18],[19,6,19,8],[21,0,21,3],[18,3,18,4],[19,3,19,4],[18,0,18,2],[19,0,19,2],[16,0,17,4],[23,0,24,4],[19,9,19,12],[20,6,20,12],[21,6,21,12]]}
["VinPro Bottling Specification Sheet – Winery Info (For Bottling Only)"]
[null,"Customer:",{"$f":"'Bottling Spec'!$B$2","v":0},null,null,null,null,"Product to Bottle:",null,{"$f":"'Bottling Spec'!$B$5","v":0}]
[null,"Winery Contact:",null,null,null,null,null,"Email :"]
["Rev. 11/20","Bottling Date Booked: (Office use only)",null,null,null,null,null,"Job Number: (Office use only)"]
[null,null,null,null,null,"                           "]
["Final Volume Expected:",null,null,null,"litres",null,"Winemakers Presence Required for Taste Off?"]
["FSO2:",null,"ppm"]
["CO2:",null,"ppm",null,null,null,"Winemakers Name:"]
[null,null,null,null,null,null,"Contact Phone Number:"]
["Last Filtration:",null,null,null,null,null,"WECS Winemaker Ref:"]
["Last Filtration Date:"]
[]
[null,null,null,null,null,null,"Contact for Lab Results:",null,null,"Name:"]
["Retention Wine Samples Required:",null,null,null,null,null,null,null,null,"Phone:"]
["Amount of Samples Taken:",null,null,null,"bottles"]
[null,null,"Reason:"]
[null,null,null,null,null,null,"Gas Cover Required in Tankers:"]
[]
["Wine to be Collected From:"]
["Requested Collection Time:",null,null,null,null,null,"Bottling Instructions/Comments:"]
[]
["Bottling Line Filter(s) Required at Vinpro:"]

{"sheet":"Labelling Spec","index":2,"n_rows":47,"n_cols":8,"rows_kept":47,"cut":false,"hidden":false,"merged":[[10,1,10,2],[10,3,10,4],[10,5,10,6],[10,7,10,8],[1,1,1,2],[1,3,1,4],[1,7,1,8],[46,0,50,0],[4,4,4,5],[15,1,15,8],[25,1,25,8],[38,1,38,8],[45,0,45,8],[5,0,5,8],[6,1,6,2],[7,1,7,2],[8,1,8,2],[9,1,9,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[20,1,20,2],[21,1,21,2],[22,1,22,2],[14,1,14,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[31,1,31,2],[32,1,32,2],[0,0,0,8],[2,1,2,2],[2,4,2,5],[2,7,2,8],[3,1,3,4],[17,5,17,6],[18,5,18,6],[6,3,6,4],[7,3,7,4],[8,3,8,4],[9,3,9,4],[11,3,11,4],[12,3,12,4],[13,3,13,4],[14,3,14,4],[16,3,16,4],[6,5,6,6],[7,5,7,6],[8,5,8,6],[9,5,9,6],[11,5,11,6],[12,5,12,6],[19,5,19,6],[20,5,20,6],[21,5,21,6],[22,5,22,6],[23,5,23,6],[24,5,24,6],[24,3,24,4],[17,3,17,4],[18,3,18,4],[19,3,19,4],[20,3,20,4],[13,5,13,6],[14,5,14,6],[16,5,16,6],[36,1,36,2],[37,1,37,2],[39,1,39,2],[40,1,40,2],[42,1,42,2],[21,3,21,4],[22,3,22,4],[23,3,23,4],[33,1,33,2],[34,1,34,2],[26,1,26,2],[27,1,27,2],[28,1,28,2],[29,1,29,2],[30,1,30,2],[23,1,23,2],[24,1,24,2],[28,3,28,4],[29,3,29,4],[30,3,30,4],[36,3,36,4],[37,3,37,4],[35,1,35,2],[35,3,35,4],[36,5,36,6],[37,5,37,6],[31,3,31,4],[32,3,32,4],[33,3,33,4],[34,3,34,4],[26,3,26,4],[27,3,27,4],[26,5,26,6],[27,5,27,6],[28,5,28,6],[29,5,29,6],[30,5,30,6],[31,5,31,6],[32,5,32,6],[33,5,33,6],[34,5,34,6],[35,5,35,6],[39,5,39,6],[40,5,40,6],[42,5,42,6],[41,5,41,6],[43,5,43,6],[44,5,44,6],[39,3,39,4],[40,3,40,4],[42,3,42,4],[41,3,41,4],[43,3,43,4],[12,7,12,8],[13,7,13,8],[14,7,14,8],[16,7,16,8],[17,7,17,8],[6,7,6,8],[7,7,7,8],[8,7,8,8],[9,7,9,8],[11,7,11,8],[23,7,23,8],[24,7,24,8],[26,7,26,8],[27,7,27,8],[28,7,28,8],[18,7,18,8],[19,7,19,8],[20,7,20,8],[21,7,21,8],[22,7,22,8],[34,7,34,8],[36,7,36,8],[37,7,37,8],[39,7,39,8],[29,7,29,8],[30,7,30,8],[31,7,31,8],[32,7,32,8],[33,7,33,8],[35,7,35,8],[46,1,46,8],[47,1,47,8],[48,1,48,8],[49,1,49,8],[50,1,50,8],[40,7,40,8],[42,7,42,8],[41,7,41,8],[43,7,43,8],[44,7,44,8],[44,3,44,4],[41,1,41,2],[43,1,43,2],[44,1,44,2]]}
["VinPro Labelling Only Specification Sheet"]
["Customer: ",null,null,"Client Required at Startup: ",null,null,"Client Name:"]
["Contact Name: ",null,null,"Phone: ",null,null,"Email: "]
["Product to Label: ",null,null,null,null,"Organic:",null,"Biogro #: "]
["Dozen to Book: ",null,"Labelling Date:",null,"Date Received:(Office use only)  ",null,null,"Job #: (Office use only)"]
[]
["WINE & CAPSULE",1]
["Wine Arrival Date at VP:",null,null,{"$f":"IF(OR(B8=\"\",D$7=\"\"),\"\",B8)","v":""},null,{"$f":"IF(OR(D8=\"\",F$7=\"\"),\"\",D8)","v":""},null,{"$f":"IF(OR(F8=\"\",H$7=\"\"),\"\",F8)","v":""}]
["Wine Currently Packed In:",null,null,"",null,"",null,""]
["Bottle Type:",null,null,"",null,"",null,""]
["Bottle Laser Code:",null,null,{"$f":"IF(OR(B11=\"\",D$7=\"\"),\"\",B11)","v":""},null,{"$f":"IF(OR(B11=\"\",F$7=\"\"),\"\",B11)","v":""},null,{"$f":"IF(OR(F11=\"\",H$8=\"\"),\"\",F11)","v":""}]
["Re-using Old Cartons:",null,null,"",null,"",null,""]
["Capsule Type:",null,null,"",null,"",null,""]
["Capsule Supplier:",null,null,"",null,"",null,""]
["Capsule Colour:",null,null,"",null,"",null,""]
["ASSEMBLIES & LABELS"]
["Quantity To Produce: "]
["Pack Type:",null,null,{"$f":"IF(OR(B18=\"\",D$7=\"\"),\"\",B18)","v":""},null,{"$f":"IF(OR(D18=\"\",F$7=\"\"),\"\",D18)","v":""},null,{"$f":"IF(OR(F18=\"\",H$7=\"\"),\"\",F18)","v":""}]
["Country on Label:",null,null,"",null,"",null,""]
["Extra Label Information:",null,null,"",null,"",null,""]
["Runout (indicate with #):",null,null,"",null,"",null,""]
["Label Type:",null,null,"",null,"",null,""]
["Front Label Height (in mm):",null,null,"",null,"",null,""]
["Back Label Height (in mm):",null,null,"",null,"",null,""]
["Label Supplier:",null,null,"",null,"",null,""]
["CARTONS & MARKINGS"]
["Carton Type:",null,null,{"$f":"IF(OR(B27=\"\",D$7=\"\"),\"\",B27)","v":""},null,{"$f":"IF(OR(D27=\"\",F$7=\"\"),\"\",D27)","v":""},null,{"$f":"IF(OR(F27=\"\",H$7=\"\"),\"\",F27)","v":""}]
["Carton Supplier:",null,null,"",null,"",null,""]
["Carton Supplier Code:",null,null,"",null,"",null,""]
["Carton Markings :",null,null,"",null,"",null,""]
["Text on Barcode:",{"$f":"IF(OR(B$30=\"None\",B$30=\"Client Supplied Carton Label\",B$30=\"VinPro Produced Label\"),\"N/A\",\"\")","v":""},null,{"$f":"IF(OR(D$30=\"None\",D$30=\"Client Supplied Carton Label\",D$30=\"VinPro Produced Label\"),\"N/A\",\"\")","v":""},null,{"$f":"IF(OR(F$30=\"None\",F$30=\"Client Supplied Carton Label\",F$30=\"VinPro Produced Label\"),\"N/A\",\"\")","v":""},null,{"$f":"IF(OR(H$30=\"None\",H$30=\"Client Supplied Carton Label\",H$30=\"VinPro Produced Label\"),\"N/A\",\"\")","v":""}]
["Barcode Number:",{"$f":"IF(OR(B$30=\"None\",B$30=\"Client Supplied Carton Label\",B$30=\"VinPro Produced Label\"),\"N/A\",\"\")","v":""},null,{"$f":"IF(OR(D$30=\"None\",D$30=\"Client Supplied Carton Label\",D$30=\"VinPro Produced Label\"),\"N/A\",\"\")","v":""},null,{"$f":"IF(OR(F$30=\"None\",F$30=\"Client Supplied Carton Label\",F$30=\"VinPro Produced Label\"),\"N/A\",\"\")","v":""},null,{"$f":"IF(OR(H$30=\"None\",H$30=\"Client Supplied Carton Label\",H$30=\"VinPro Produced Label\"),\"N/A\",\"\")","v":""}]
["Front Bottle Label:",null,null,"",null,"",null,""]
["Inkjet Code Required:",null,null,"",null,"",null,""]
["Inkjet Code Text:",null,null,"",null,"",null,""]
["Pregnancy Warning Required:"]
["Dividers:",null,null,"",null,"",null,""]
["Dividers Supplier:",null,null,"",null,"",null,""]
["PALLETS & STORAGE"]
["Pallet Type:",null,null,{"$f":"IF(OR(B40=\"\",D$7=\"\"),\"\",B40)","v":""},null,{"$f":"IF(OR(D40=\"\",F$7=\"\"),\"\",D40)","v":""},null,{"$f":"IF(OR(F40=\"\",H$7=\"\"),\"\",F40)","v":""}]
["Pallet Wrapping:",null,null,"",null,"",null,""]
["Finished Wine Storage:",null,null,"",null,"",null,""]
["Finished Wine Transport: ",null,null,"",null,"",null,""]
["Dry Goods Storage:",null,null,"",null,"",null,""]
["Label Storage:",null,null,"",null,"",null,""]
[]
["COMMENTS:"]

{"sheet":"Sticker Placement","index":3,"n_rows":6,"n_cols":11,"rows_kept":6,"cut":false,"hidden":false,"merged":[[5,1,9,3],[5,5,9,7],[5,10,8,11],[0,0,1,13]]}
["CARTON AND MEDAL STICKER VISUAL PLACEMENT"]
[]
[]
[]
[]
[null,"FRONT BOTTLE LABELS",null,null,null,"BARCODES",null,null,null,null,"MEDAL STICKERS"]

{"sheet":"Tankers Reference","index":4,"n_rows":42,"n_cols":9,"rows_kept":42,"cut":false,"hidden":false,"merged":[[0,1,1,7],[8,6,8,8],[40,1,40,2],[37,1,37,2],[32,1,32,3],[2,1,4,6]]}
[null,"Determining Tanker Requirements (optional)"]
[]
["Instructions:","Choose the tanker combination you require under the Selected column. If necessary, enter the volume needed under Capacity for each VC selected - no more than 1500L per VC and 1000L per Pallecon. Only the yellow cells can be populated manually.\nCheck (at the bottom) will show red until the selected volumes match your Total Litres.\nDisclaimer: This is only a guide. Tankers are subject to availability. Please contact our Production Planner to organise ahead of your bottling date."]
[]
[]
[]
["Total Litres:",{"$f":"'Bottling Spec'!$B$6","v":0}]
[]
["Selected","Tanker","Capacity","Code","Tanker Volume Selected",null,"TANKER CAPACITY"]
["No","VP Winery Direct",null,"VinPro",{"$f":"IF(A10=\"Yes\",C10,0)","v":0},null,"Tanker 1 - Front",3143,"T1F"]
["No","COWCO Direct",null,"COWCO",{"$f":"IF(A11=\"Yes\",C11,0)","v":0},null,"Tanker 1 - Back",5079,"T1B"]
["No","Client Tanker",null,"CLIENT",{"$f":"IF(A12=\"Yes\",C12,0)","v":0},null,"Tanker 2 - Front",3700,"T2F"]
["No","Tanker 1 - Front",3143,"T1F",{"$f":"IF(A13=\"Yes\",C13,0)","v":0},null,"Tanker 2 - Back",5868,"T2B"]
["No","Tanker 1 - Back",5079,"T1B",0,null,"Tanker 3 - Front",3809,"T3F"]
["No","Tanker 2 - Front",3700,"T2F",0,null,"Tanker 3 - Back",5844,"T3B"]
["No","Tanker 2 - Back",5868,"T2B",0,null,"Tanker 4 - Front",8880,"T4F"]
["No","Tanker 3 - Front",3809,"T3F",0,null,"Tanker 4 - Back",6505,"T4B"]
["No","Tanker 3 - Back",5844,"T3B",0,null,"Tanker 5 - Front",5380,"T5F"]
["No","Tanker 4 - Front",8880,"T4F",0,null,"Tanker 5 - Back",11090,"T5B"]
["No","Tanker 4 - Back",6505,"T4B",0,null,null,{"$f":"SUM(H10:H19)","v":59298}]
["No","Tanker 5 - Front",5380,"T5F",0]
["No","Tanker 5 - Back",11090,"T5B",0]
["No","SS1",1228,"SS1",0]
["No","SS2",5441,"SS2",0]
["No","SS3",2420,"SS3",0]
["No","Pallecon 1",null,"P01",0]
["No","Pallecon 2",null,"P02",0]
["No","Pallecon 3",null,"P03",0]
["No","VC Tank (max 1500L)",null,"VC1",0]
["No","VC Tank (max 1500L)",null,"VC2",0]
["No","VC Tank (max 1500L)",null,"VC3",0]
[]
[null,"Total Tanker + Pallecon volume:",null,null,{"$f":"SUM(E10:E31)","v":0},"litres"]
[]
[null,null,null,"Check:",{"$f":"E33-B7","v":0},"Should be 0"]
[]
[]
[null,"Number of VCs used:",null,{"$f":"COUNTIF(A26:A31,\"yes\")","v":0}]
[null,null,"Total VC volume:",{"$f":"SUM(E26:E31)","v":0}]
[]
[null,"Tankers Selected:",null,{"$f":"IF(ISNA(VLOOKUP(\"Yes\",A10:E25,4,FALSE)),\"\",VLOOKUP(\"Yes\",A10:E25,4,FALSE))","v":""},{"$f":"IFERROR(INDEX($A$10:$D$25,SMALL(IF($A$10:$D$25=\"Yes\",ROW($A$10:$D$25)-ROW($A$10)+1,ROW($D$25)+1),2),4),\"\")","v":""}]
[null,null,null,{"$f":"IFERROR(INDEX($A$10:$D$25,SMALL(IF($A$10:$D$25=\"Yes\",ROW($A$10:$D$25)-ROW($A$10)+1,ROW($D$25)+1),3),4),\"\")","v":""},{"$f":"IFERROR(INDEX($A$10:$D$25,SMALL(IF($A$10:$D$25=\"Yes\",ROW($A$10:$D$25)-ROW($A$10)+1,ROW($D$25)+1),4),4),\"\")","v":""}]

{"sheet":"Dry Goods Availability","index":5,"n_rows":15,"n_cols":14,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,8,1,9],[1,10,1,11],[1,12,1,13],[0,0,0,13]]}
["DRY GOODS AVAILABILITY AT VINPRO"]
["Bottle Type","Antique Green","French Green","Arctic Blue","Flint (Clear)",null,null,"Case Type","Central Otago",null,"Kraft (Plain Brown)",null,"White"]
["OI L/W Trad Burg 417g","Available","Available","Available","Available",null,null,"Bottle Type","6 pack","12 pack","6 pack","12 pack","6 pack","12 pack"]
["OI H/W Trad Burg 565 g","Available","Available","N/A","N/A",null,null,"Trad Burg","Available","Available","Available","Available","Available","N/A"]
["OI Prem Burg 545 g","Available","N/A","N/A","Available",null,null,"Prem Burg","N/A","Available","Available","Available","Available","Available"]
["OI Square Heel Prem Burg 545 g","Available","N/A","N/A","N/A",null,null,"Riesling","N/A","Available","N/A","Available","Available","N/A"]
["750ml Square Heel Prem Burg LW 495g","Available","N/A","N/A","N/A",null,null,"Bordeaux","N/A","N/A","N/A","N/A","Available","Available"]
["OI Grande Burg 702 g","Available","N/A","N/A","N/A",null,null,"Grande Burg","N/A","Available","N/A","N/A","N/A","Available"]
["OI Bordeaux","N/A","N/A","N/A","Available",null,null,"375 mL Trad","N/A","N/A","N/A","Available","N/A","N/A"]
["OI Riesling","Available","N/A","N/A","N/A",null,null,"375 mL Bordeaux","N/A","N/A","N/A","Available","N/A","N/A"]
["OI 375 mL Trad","N/A","Available","N/A","N/A",null,null,"375 mL Riesling","N/A","N/A","N/A","Available","N/A","N/A"]
["CAL 375 mL","Available","N/A","N/A","N/A",null,null,"Magnum","N/A","N/A","Available","N/A","N/A","N/A"]
["OI 375 mL Bordeaux","N/A","N/A","N/A","Available",null,null,"Prem Burg Layflat","Available","Available","N/A","N/A","N/A","N/A"]
["Renana / 375 mL Riesling","Available","N/A","N/A","Available",null,null,"Trad Burg Layflat","N/A","N/A","Available","N/A","N/A","N/A"]
[null,null,null,null,null,null,null,"Universal Layflat","Available","N/A","N/A","N/A","N/A","N/A"]

{"sheet":"Glass Codes","index":6,"n_rows":27,"n_cols":6,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[]
["Short Bottle Code","Volume","375ml Bottles"]
["375ml Antique Green Trad",0.375,"Antique Green Trad Burgundy 375ml bottle"]
["375ml Flint Bordeaux",0.375,"Flint Bordeaux 375ml bottle"]
["375ml Flint Renana",0.375,"Riesling s/cap Flint (Renana) 375ml bottle"]
["375ml Antique Green Renana",0.375,"Riesling s/cap AG Green (Renana) 375ml bottle"]
[null,null,"750ml Bottles"]
["750ml Antique Green LW Trad 417g",0.75,"Antique Green Light Weight (417g) Trad Burgundy 750ml bottle "]
["750ml French Green LW Trad  417g",0.75," French Green Light Weight (417g) Trad Burgundy 750ml bottle "]
["750ml Flint LW Trad 417g",0.75,"Flint Light Weight (417g) Trad Burgundy 750ml bottle "]
["750ml Arctic Blue LW Trad 417g",0.75,"Artic Blue Light Weight (417g)Trad Burgundy 750ml bottle ",null,null," "]
["750ml Antique Green LW Trad 390g",0.75,"Antique Green Light Weight (390g) Trad Burgundy 750ml bottle"]
["750ml Flint LW Trad 390g",0.75,"Flint Light Weight (390g) Trad Burgundy 750ml bottle"]
["750ml Antique Green Square Heel Prem Burg LW 495g",0.75," Antique Green Light Weight Premium Burgundy (495g) Square Heel 750ml bottle "]
["750ml Antique Green Square Heel Prem Burg 545g",0.75," Antique Green Premium Burgundy (545g) Square Heel 750ml bottle "]
["750ml Flint Square Heel Prem Burg 545g",0.75,"Flint Premium Burgundy (545g) Square Heel 750ml bottle "]
["750ml Antique Green Prem Cork",0.75,"Antique Green Prem Burgundy Cork  750ml bottle"]
["750ml Antique Green Riesling ",0.75,"Antique Green Riesling (518g) 750ml bottle "]
["750ml Antique Green Bordeaux",0.75,"Antique Green Bordeaux  750ml Bottle "]
["750ml Flint Bordeaux",0.75,"Flint Bordeaux  750ml Bottle "]
[null,null,"Magnum Bottles"]
["1.5L Antique Green Small Bore Cork Mag",1.5,"Antique Green Small Bore Cork Magnum (24mm cork)"]
["1.5L Antique Green Large Bore Cork Mag",1.5,"Antique Green Big Bore Cork Magnum Antique Green (28mm cork)"]
["1.5L Antique Green Screwcap Mag",1.5," Antique Green Screwcap Magnum"]
["1.5L Flint Screwcap Mag",1.5,"Flint Screwcap Magnum"]
[null,null,"Large Formats"]
["3L Jeroboams",3,"3 litres Jeroboams"]